package com.baturu.vin.benz.cleanData.constants;

import com.baturu.vin.benz.cleanData.dto.ColumnDTO;
import com.baturu.vin.benz.cleanData.dto.TableDTO;
import com.google.common.collect.Lists;

import java.io.Serializable;
import java.util.List;

/**
 * @Author: jiangxinlei
 * @Time: 2018/3/6 16:30
 **/
public class TableInfo implements Serializable {

    protected final static String NEWDATA = "_newdata";

   /* public static List<TableDTO> tempDeal() {
        return Lists.newArrayList(bm_spm_v());
    }*/

    public static List<TableDTO> getCommonTables() {
        return Lists.newArrayList(
                appl_cat_base_v(),
                //其他方法处理
//                benz_callout_position(),
                bm_aggchass_v(),
                bm_compmdl_v(),
                bm_dictionary_v(),
                bm_footnotes_dictionary_v(),
                bm_footnotes_v2(),
                bm_group_v(),
                bm_npg_v(),
//                bm_parts2_v(),
                bm_subgrp_v(),
                dc_rtype1_v_dag_dccv(),
                dc_rtype1_v_dag_dcpc(),
                dc_rtype1_v_dcex_dcex(),
                dc_rtype1_v_mbja_dcja(),
                dc_rtype1_v_mbla_dcla(),
                dc_rtype1_v_mbna_dcna(),
                dc_rtype1_v_mboe_dccar(),
                dc_rtype1_v_mboe_dcgwgn(),
                dc_rtype1_v_mbsm_dcsm(),
                dc_rtype3_v_dag_dccv(),
                dc_rtype3_v_dag_dcpc(),
                dc_rtype3_v_dcex_dcex(),
                dc_rtype3_v_mbja_dcja(),
                dc_rtype3_v_mbla_dcla(),
                dc_rtype3_v_mbna_dcna(),
                dc_rtype3_v_mboe_dccar(),
                dc_rtype3_v_mboe_dcgwgn(),
                dc_rtype3_v_mbsm_dcsm(),
//                dc_rtype1_v_dcbus(),
//                dc_rtype3_v_dcbus(),
//                dc_rtype1_v_dctrac(),
//                dc_rtype3_v_dctrac(),
//                dc_rtype1_v_dctran(),
//                dc_rtype3_v_dctran(),
//                dc_rtype1_v_dctrk(),
//                dc_rtype3_v_dctrk(),
//                dc_rtype1_v_dcumog(),
//                dc_rtype3_v_dcumog(),
                models_v(),
                part_descs_v(),
                part_nouns_v(),
                sa_codes2_v(),
                benz_spring_parts_v(),
                dc_map_v()
        );
    }

   /* protected static TableDTO bm_spm_v() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("CATNUM").desColumn("CATNUM").build(),
                ColumnDTO.builder().originColumn("MODEL").desColumn("MODEL").build(),
                ColumnDTO.builder().originColumn("LANG").desColumn("LANG").build(),
                ColumnDTO.builder().originColumn("SEQNUM").desColumn("SEQNUM").build(),
                ColumnDTO.builder().originColumn("FRONTAX").desColumn("FRONTAX").build(),
                ColumnDTO.builder().originColumn("STEER").desColumn("STEER").build(),
                ColumnDTO.builder().originColumn("REARAX").desColumn("REARAX").build(),
                ColumnDTO.builder().originColumn("CONTFLG").desColumn("CONTFLG").build(),
                ColumnDTO.builder().originColumn("A_BODY").desColumn("A_BODY").build(),
                ColumnDTO.builder().originColumn("DIST").desColumn("DIST").build(),
                ColumnDTO.builder().originColumn("ENGINE").desColumn("ENGINE").build(),
                ColumnDTO.builder().originColumn("PLATFRM").desColumn("PLATFRM").build(),
                ColumnDTO.builder().originColumn("AUTO").desColumn("AUTO").build(),
                ColumnDTO.builder().originColumn("SALESD").desColumn("SALESD").build(),
                ColumnDTO.builder().originColumn("NUMRECS").desColumn("NUMRECS").build(),
                ColumnDTO.builder().originColumn("MANUAL").desColumn("MANUAL").build(),
                ColumnDTO.builder().originColumn("TEXT").desColumn("TEXT").build(),
                ColumnDTO.builder().originColumn("FUELCELL").desColumn("FUELCELL").build(),
                ColumnDTO.builder().originColumn("HVBATTERY").desColumn("HVBATTERY").build(),
                ColumnDTO.builder().originColumn("EMOTOR").desColumn("EMOTOR").build(),
                ColumnDTO.builder().originColumn("EXHAUSTSYS").desColumn("EXHAUSTSYS").build());
        String tableName = TableEnum.BM_SPM_V.getName();
        String dataBaseName = TableEnum.BM_SPM_V.getDataBaseName();
        return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from "+tableName+" where LANG in ('E','Z')").desTable(tableName + NEWDATA).columns(columns).build();
    }*/

    protected static TableDTO appl_cat_base_v() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("CATNUM").desColumn("CATNUM").build(),
                ColumnDTO.builder().originColumn("MARKETS").desColumn("MARKETS").build(),
                ColumnDTO.builder().originColumn("MODEL_YEAR").desColumn("MODEL_YEAR").build(),
                ColumnDTO.builder().originColumn("DATE_FROM").desColumn("DATE_FROM").build(),
                ColumnDTO.builder().originColumn("DATE_TO").desColumn("DATE_TO").build(),
                ColumnDTO.builder().originColumn("COMPACT_VERSION").desColumn("COMPACT_VERSION").build(),
                ColumnDTO.builder().originColumn("REMARKS").desColumn("REMARKS").build(),
                ColumnDTO.builder().originColumn("IDENT_CTL1").desColumn("IDENT_CTL1").build(),
                ColumnDTO.builder().originColumn("IDENT1").desColumn("IDENT1").build(),
                ColumnDTO.builder().originColumn("IDENT_CTL2").desColumn("IDENT_CTL2").build(),
                ColumnDTO.builder().originColumn("IDENT2").desColumn("IDENT2").build(),
                ColumnDTO.builder().originColumn("IDENT_CTL3").desColumn("IDENT_CTL3").build(),
                ColumnDTO.builder().originColumn("IDENT3").desColumn("IDENT3").build(),
                ColumnDTO.builder().originColumn("IDENT_CTL4").desColumn("IDENT_CTL4").build(),
                ColumnDTO.builder().originColumn("IDENT4").desColumn("IDENT4").build(),
                ColumnDTO.builder().originColumn("IDENT_CTL5").desColumn("IDENT_CTL5").build(),
                ColumnDTO.builder().originColumn("IDENT5").desColumn("IDENT5").build(),
                ColumnDTO.builder().originColumn("IDENT_CTL6").desColumn("IDENT_CTL6").build(),
                ColumnDTO.builder().originColumn("IDENT6").desColumn("IDENT6").build());
        String tableName = TableEnum.APPL_CAT_BASE_V.getName();
        String dataBaseName = TableEnum.APPL_CAT_BASE_V.getDataBaseName();
        return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from "+tableName).desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO benz_spring_parts_v() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("WHC").desColumn("WHC").build(),
                ColumnDTO.builder().originColumn("CHASSBM").desColumn("CHASSBM").build(),
                ColumnDTO.builder().originColumn("CHASS_IDENT").desColumn("CHASS_IDENT").build(),
                ColumnDTO.builder().originColumn("FRONT_SPRING_STRUT").desColumn("FRONT_SPRING_STRUT").build(),
                ColumnDTO.builder().originColumn("FRONT_SPRING").desColumn("FRONT_SPRING").build(),
                ColumnDTO.builder().originColumn("REAR_SPRING").desColumn("REAR_SPRING").build(),
                ColumnDTO.builder().originColumn("REAR_SPRING_SUPPL").desColumn("REAR_SPRING_SUPPL").build());
        String tableName = TableEnum.BENZ_SPRING_PARTS_V.getName();
        String dataBaseName = TableEnum.BENZ_SPRING_PARTS_V.getDataBaseName();
        return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from spring_parts_v").desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO bm_aggchass_v() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("MODEL").desColumn("MODEL").build(),
                ColumnDTO.builder().originColumn("CATNUM").desColumn("CATNUM").build(),
                ColumnDTO.builder().originColumn("CHASSIS").desColumn("CHASSIS").build());
        String tableName = TableEnum.BM_AGGCHASS_V.getName();
        String dataBaseName = TableEnum.BM_AGGCHASS_V.getDataBaseName();
        return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from "+tableName).desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO bm_compmdl_v() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("CATNUM").desColumn("CATNUM").build(),
                ColumnDTO.builder().originColumn("MODEL").desColumn("MODEL").build(),
                ColumnDTO.builder().originColumn("SEQNUM").desColumn("SEQNUM").build(),
                ColumnDTO.builder().originColumn("STROKES").desColumn("STROKES").build(),
                ColumnDTO.builder().originColumn("COMP").desColumn("COMP").build());
        String tableName = TableEnum.BM_COMPMDL_V.getName();
        String dataBaseName = TableEnum.BM_COMPMDL_V.getDataBaseName();
        return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from "+tableName).desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO bm_dictionary_v() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("DESCIDX").desColumn("DESCIDX").build(),
                ColumnDTO.builder().originColumn("LANG").desColumn("LANG").build(),
                ColumnDTO.builder().originColumn("TEXT").desColumn("TEXT").build());
        String tableName = TableEnum.BM_DICTIONARY_V.getName();
        String dataBaseName = TableEnum.BM_DICTIONARY_V.getDataBaseName();
        return TableDTO.builder().dataBaseName(dataBaseName).querySql("SELECT * FROM bm_dictionary_v where LANG='Z'\n" +
                "UNION ALL SELECT * FROM bm_dictionary_v where LANG='E' and DESCIDX not in (SELECT DISTINCT DESCIDX FROM bm_dictionary_v where LANG='Z')")
                .desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO bm_footnotes_dictionary_v() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("DESCIDX").desColumn("DESCIDX").build(),
                ColumnDTO.builder().originColumn("LANG").desColumn("LANG").build(),
                ColumnDTO.builder().originColumn("SEQNUM").desColumn("SEQNUM").build(),
                ColumnDTO.builder().originColumn("CONTINUED").desColumn("CONTINUED").build(),
                ColumnDTO.builder().originColumn("ABBR").desColumn("ABBR").build(),
                ColumnDTO.builder().originColumn("TEXT").desColumn("TEXT").build());
        String tableName = TableEnum.BM_FOOTNOTES_DICTIONARY_V.getName();
        String dataBaseName = TableEnum.BM_FOOTNOTES_DICTIONARY_V.getDataBaseName();return TableDTO.builder().dataBaseName(dataBaseName).querySql("SELECT * FROM bm_footnotes_dictionary_v where LANG IN ('N','Z','E')").desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO bm_footnotes_v2() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("CATNUM").desColumn("CATNUM").build(),
                ColumnDTO.builder().originColumn("GROUPNUM").desColumn("GROUPNUM").build(),
                ColumnDTO.builder().originColumn("FTNTNUM").desColumn("FTNTNUM").build(),
                ColumnDTO.builder().originColumn("DESCIDX").desColumn("DESCIDX").build(),
                ColumnDTO.builder().originColumn("REVVER").desColumn("REVVER").build(),
                ColumnDTO.builder().originColumn("LISTNUM").desColumn("LISTNUM").build(),
                ColumnDTO.builder().originColumn("HAS_WISLINK").desColumn("HAS_WISLINK").build(),
                ColumnDTO.builder().originColumn("KB").desColumn("KB").build());
        String tableName = TableEnum.BM_FOOTNOTES_V2.getName();
        String dataBaseName = TableEnum.BM_FOOTNOTES_V2.getDataBaseName();return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from "+tableName).desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO bm_group_v() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("CATNUM").desColumn("CATNUM").build(),
                ColumnDTO.builder().originColumn("GROUPNUM").desColumn("GROUPNUM").build(),
                ColumnDTO.builder().originColumn("ILLCNT").desColumn("ILLCNT").build(),
                ColumnDTO.builder().originColumn("DESCIDX").desColumn("DESCIDX").build());
        String tableName = TableEnum.BM_GROUP_V.getName();
        String dataBaseName = TableEnum.BM_GROUP_V.getDataBaseName();return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from "+tableName).desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO bm_npg_v() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("CATNUM").desColumn("CATNUM").build(),
                ColumnDTO.builder().originColumn("GROUPNUM").desColumn("GROUPNUM").build(),
                ColumnDTO.builder().originColumn("SEQNUM").desColumn("SEQNUM").build(),
                ColumnDTO.builder().originColumn("RESTIMG").desColumn("RESTIMG").build(),
                ColumnDTO.builder().originColumn("SUBGRP").desColumn("SUBGRP").build(),
                ColumnDTO.builder().originColumn("CALLOUT").desColumn("CALLOUT").build(),
                ColumnDTO.builder().originColumn("CONTREC").desColumn("CONTREC").build(),
                ColumnDTO.builder().originColumn("SEQNO").desColumn("SEQNO").build(),
                ColumnDTO.builder().originColumn("IMGTYPE").desColumn("IMGTYPE").build(),
                ColumnDTO.builder().originColumn("ARCHIVED").desColumn("ARCHIVED").build());
        String tableName = TableEnum.BM_NPG_V.getName();
        String dataBaseName = TableEnum.BM_NPG_V.getDataBaseName();return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from "+tableName).desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO bm_subgrp_v() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("CATNUM").desColumn("CATNUM").build(),
                ColumnDTO.builder().originColumn("GROUPNUM").desColumn("GROUPNUM").build(),
                ColumnDTO.builder().originColumn("LANG").desColumn("LANG").build(),
                ColumnDTO.builder().originColumn("SUBGRP").desColumn("SUBGRP").build(),
                ColumnDTO.builder().originColumn("TEXT").desColumn("TEXT").build());
        String tableName = TableEnum.BM_SUBGRP_V.getName();
        String dataBaseName = TableEnum.BM_SUBGRP_V.getDataBaseName();return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from "+tableName).desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO dc_map_v() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("WHC").desColumn("WHC").build(),
                ColumnDTO.builder().originColumn("CHASSBM").desColumn("CHASSBM").build(),
                ColumnDTO.builder().originColumn("CHASS_IDENT").desColumn("CHASS_IDENT").build(),
                ColumnDTO.builder().originColumn("VINWHC").desColumn("VINWHC").build(),
                ColumnDTO.builder().originColumn("VIN").desColumn("VIN").build(),
                ColumnDTO.builder().originColumn("LOCATION").desColumn("LOCATION").build(),
                ColumnDTO.builder().originColumn("HAS_R2").desColumn("HAS_R2").build(),
                ColumnDTO.builder().originColumn("HAS_R5").desColumn("HAS_R5").build(),
                ColumnDTO.builder().originColumn("HAS_R7").desColumn("HAS_R7").build(),
                ColumnDTO.builder().originColumn("HAS_RA").desColumn("HAS_RA").build(),
                ColumnDTO.builder().originColumn("HAS_RT").desColumn("HAS_RT").build(),
                ColumnDTO.builder().originColumn("HAS_RY").desColumn("HAS_RY").build(),
                ColumnDTO.builder().originColumn("VIN8").desColumn("VIN8").build(),
                ColumnDTO.builder().originColumn("HAS_R4").desColumn("HAS_R4").build());
        String tableName = TableEnum.DC_MAP_V.getName();
        String dataBaseName = TableEnum.DC_MAP_V.getDataBaseName();return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from "+tableName).desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO dc_rtype1_v_dag_dccv() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("WHC").desColumn("WHC").build(),
                ColumnDTO.builder().originColumn("CHASSBM").desColumn("CHASSBM").build(),
                ColumnDTO.builder().originColumn("CHASS_IDENT").desColumn("CHASS_IDENT").build(),
                ColumnDTO.builder().originColumn("VEHICLE_CATEGORY").desColumn("VEHICLE_CATEGORY").build(),
                ColumnDTO.builder().originColumn("ENGINE").desColumn("ENGINE").build(),
                ColumnDTO.builder().originColumn("TRANSMISSION").desColumn("TRANSMISSION").build(),
                ColumnDTO.builder().originColumn("STEERING").desColumn("STEERING").build(),
                ColumnDTO.builder().originColumn("BODY").desColumn("BODY").build(),
                ColumnDTO.builder().originColumn("FRONT_AXLE1").desColumn("FRONT_AXLE1").build(),
                ColumnDTO.builder().originColumn("FRONT_AXLE2").desColumn("FRONT_AXLE2").build(),
                ColumnDTO.builder().originColumn("REAR_AXLE1").desColumn("REAR_AXLE1").build(),
                ColumnDTO.builder().originColumn("REAR_AXLE2").desColumn("REAR_AXLE2").build(),
                ColumnDTO.builder().originColumn("TRANSFER_CASE").desColumn("TRANSFER_CASE").build(),
                ColumnDTO.builder().originColumn("PLATFORM").desColumn("PLATFORM").build(),
                ColumnDTO.builder().originColumn("BODY_CODE").desColumn("BODY_CODE").build(),
                ColumnDTO.builder().originColumn("MODEL_IDX").desColumn("MODEL_IDX").build(),
                ColumnDTO.builder().originColumn("ORDER_NUM1").desColumn("ORDER_NUM1").build(),
                ColumnDTO.builder().originColumn("PRODUCTION_NUM1").desColumn("PRODUCTION_NUM1").build(),
                ColumnDTO.builder().originColumn("AUXILIARY_DRIVE").desColumn("AUXILIARY_DRIVE").build(),
                ColumnDTO.builder().originColumn("HEATER").desColumn("HEATER").build(),
                ColumnDTO.builder().originColumn("RIMS").desColumn("RIMS").build(),
                ColumnDTO.builder().originColumn("LIGHTS").desColumn("LIGHTS").build(),
                ColumnDTO.builder().originColumn("WIPER").desColumn("WIPER").build(),
                ColumnDTO.builder().originColumn("WINCH").desColumn("WINCH").build(),
                ColumnDTO.builder().originColumn("ODOMETER").desColumn("ODOMETER").build(),
                ColumnDTO.builder().originColumn("VINWHC").desColumn("VINWHC").build(),
                ColumnDTO.builder().originColumn("VIN").desColumn("VIN").build(),
                ColumnDTO.builder().originColumn("TRAILER").desColumn("TRAILER").build(),
                ColumnDTO.builder().originColumn("INTERIOR").desColumn("INTERIOR").build(),
                ColumnDTO.builder().originColumn("PAINT1").desColumn("PAINT1").build(),
                ColumnDTO.builder().originColumn("PAINT2").desColumn("PAINT2").build(),
                ColumnDTO.builder().originColumn("PAINT3").desColumn("PAINT3").build(),
                ColumnDTO.builder().originColumn("PAINT4").desColumn("PAINT4").build(),
                ColumnDTO.builder().originColumn("PAINT5").desColumn("PAINT5").build(),
                ColumnDTO.builder().originColumn("RETARDER").desColumn("RETARDER").build(),
                ColumnDTO.builder().originColumn("DELIVERY_DATE").desColumn("DELIVERY_DATE").build(),
                ColumnDTO.builder().originColumn("PRODUCTION_ORDER_REF").desColumn("PRODUCTION_ORDER_REF").build(),
                ColumnDTO.builder().originColumn("SERVICE_NUM").desColumn("SERVICE_NUM").build(),
                ColumnDTO.builder().originColumn("RELEASE_DATE").desColumn("RELEASE_DATE").build(),
                ColumnDTO.builder().originColumn("LEADINGAGGREGATE").desColumn("LEADINGAGGREGATE").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE1").desColumn("ELECTRICALENGINE1").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE2").desColumn("ELECTRICALENGINE2").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE3").desColumn("ELECTRICALENGINE3").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE4").desColumn("ELECTRICALENGINE4").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE5").desColumn("ELECTRICALENGINE5").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE6").desColumn("ELECTRICALENGINE6").build(),
                ColumnDTO.builder().originColumn("HVBATTERY1").desColumn("HVBATTERY1").build(),
                ColumnDTO.builder().originColumn("HVBATTERY2").desColumn("HVBATTERY2").build(),
                ColumnDTO.builder().originColumn("HVBATTERY3").desColumn("HVBATTERY3").build(),
                ColumnDTO.builder().originColumn("FUELCELL1").desColumn("FUELCELL1").build(),
                ColumnDTO.builder().originColumn("FUELCELL2").desColumn("FUELCELL2").build(),
                ColumnDTO.builder().originColumn("FUELCELL3").desColumn("FUELCELL3").build(),
                ColumnDTO.builder().originColumn("EXHAUSTSYS").desColumn("EXHAUSTSYS").build(),
                ColumnDTO.builder().originColumn("FRONTAXLE3").desColumn("FRONTAXLE3").build(),
                ColumnDTO.builder().originColumn("REARAXLE3").desColumn("REARAXLE3").build(),
                ColumnDTO.builder().originColumn("REARAXLE4").desColumn("REARAXLE4").build(),
                ColumnDTO.builder().originColumn("EUAPPROVALNUM").desColumn("EUAPPROVALNUM").build(),
                ColumnDTO.builder().originColumn("EUAPPROVALDATE").desColumn("EUAPPROVALDATE").build(),
                ColumnDTO.builder().originColumn("CLUTCHVENDOR").desColumn("CLUTCHVENDOR").build());
        String tableName = TableEnum.DC_RTYPE1_V_DAG_DCCV.getName();
        String dataBaseName = TableEnum.DC_RTYPE1_V_DAG_DCCV.getDataBaseName();
        return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from dc_rtype1_v").desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO dc_rtype1_v_dag_dcpc() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("WHC").desColumn("WHC").build(),
                ColumnDTO.builder().originColumn("CHASSBM").desColumn("CHASSBM").build(),
                ColumnDTO.builder().originColumn("CHASS_IDENT").desColumn("CHASS_IDENT").build(),
                ColumnDTO.builder().originColumn("VEHICLE_CATEGORY").desColumn("VEHICLE_CATEGORY").build(),
                ColumnDTO.builder().originColumn("ENGINE").desColumn("ENGINE").build(),
                ColumnDTO.builder().originColumn("TRANSMISSION").desColumn("TRANSMISSION").build(),
                ColumnDTO.builder().originColumn("STEERING").desColumn("STEERING").build(),
                ColumnDTO.builder().originColumn("BODY").desColumn("BODY").build(),
                ColumnDTO.builder().originColumn("FRONT_AXLE1").desColumn("FRONT_AXLE1").build(),
                ColumnDTO.builder().originColumn("FRONT_AXLE2").desColumn("FRONT_AXLE2").build(),
                ColumnDTO.builder().originColumn("REAR_AXLE1").desColumn("REAR_AXLE1").build(),
                ColumnDTO.builder().originColumn("REAR_AXLE2").desColumn("REAR_AXLE2").build(),
                ColumnDTO.builder().originColumn("TRANSFER_CASE").desColumn("TRANSFER_CASE").build(),
                ColumnDTO.builder().originColumn("PLATFORM").desColumn("PLATFORM").build(),
                ColumnDTO.builder().originColumn("BODY_CODE").desColumn("BODY_CODE").build(),
                ColumnDTO.builder().originColumn("MODEL_IDX").desColumn("MODEL_IDX").build(),
                ColumnDTO.builder().originColumn("ORDER_NUM1").desColumn("ORDER_NUM1").build(),
                ColumnDTO.builder().originColumn("PRODUCTION_NUM1").desColumn("PRODUCTION_NUM1").build(),
                ColumnDTO.builder().originColumn("AUXILIARY_DRIVE").desColumn("AUXILIARY_DRIVE").build(),
                ColumnDTO.builder().originColumn("HEATER").desColumn("HEATER").build(),
                ColumnDTO.builder().originColumn("RIMS").desColumn("RIMS").build(),
                ColumnDTO.builder().originColumn("LIGHTS").desColumn("LIGHTS").build(),
                ColumnDTO.builder().originColumn("WIPER").desColumn("WIPER").build(),
                ColumnDTO.builder().originColumn("WINCH").desColumn("WINCH").build(),
                ColumnDTO.builder().originColumn("ODOMETER").desColumn("ODOMETER").build(),
                ColumnDTO.builder().originColumn("VINWHC").desColumn("VINWHC").build(),
                ColumnDTO.builder().originColumn("VIN").desColumn("VIN").build(),
                ColumnDTO.builder().originColumn("TRAILER").desColumn("TRAILER").build(),
                ColumnDTO.builder().originColumn("INTERIOR").desColumn("INTERIOR").build(),
                ColumnDTO.builder().originColumn("PAINT1").desColumn("PAINT1").build(),
                ColumnDTO.builder().originColumn("PAINT2").desColumn("PAINT2").build(),
                ColumnDTO.builder().originColumn("PAINT3").desColumn("PAINT3").build(),
                ColumnDTO.builder().originColumn("PAINT4").desColumn("PAINT4").build(),
                ColumnDTO.builder().originColumn("PAINT5").desColumn("PAINT5").build(),
                ColumnDTO.builder().originColumn("RETARDER").desColumn("RETARDER").build(),
                ColumnDTO.builder().originColumn("DELIVERY_DATE").desColumn("DELIVERY_DATE").build(),
                ColumnDTO.builder().originColumn("PRODUCTION_ORDER_REF").desColumn("PRODUCTION_ORDER_REF").build(),
                ColumnDTO.builder().originColumn("SERVICE_NUM").desColumn("SERVICE_NUM").build(),
                ColumnDTO.builder().originColumn("RELEASE_DATE").desColumn("RELEASE_DATE").build(),
                ColumnDTO.builder().originColumn("LEADINGAGGREGATE").desColumn("LEADINGAGGREGATE").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE1").desColumn("ELECTRICALENGINE1").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE2").desColumn("ELECTRICALENGINE2").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE3").desColumn("ELECTRICALENGINE3").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE4").desColumn("ELECTRICALENGINE4").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE5").desColumn("ELECTRICALENGINE5").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE6").desColumn("ELECTRICALENGINE6").build(),
                ColumnDTO.builder().originColumn("HVBATTERY1").desColumn("HVBATTERY1").build(),
                ColumnDTO.builder().originColumn("HVBATTERY2").desColumn("HVBATTERY2").build(),
                ColumnDTO.builder().originColumn("HVBATTERY3").desColumn("HVBATTERY3").build(),
                ColumnDTO.builder().originColumn("FUELCELL1").desColumn("FUELCELL1").build(),
                ColumnDTO.builder().originColumn("FUELCELL2").desColumn("FUELCELL2").build(),
                ColumnDTO.builder().originColumn("FUELCELL3").desColumn("FUELCELL3").build(),
                ColumnDTO.builder().originColumn("EXHAUSTSYS").desColumn("EXHAUSTSYS").build(),
                ColumnDTO.builder().originColumn("FRONTAXLE3").desColumn("FRONTAXLE3").build(),
                ColumnDTO.builder().originColumn("REARAXLE3").desColumn("REARAXLE3").build(),
                ColumnDTO.builder().originColumn("REARAXLE4").desColumn("REARAXLE4").build(),
                ColumnDTO.builder().originColumn("EUAPPROVALNUM").desColumn("EUAPPROVALNUM").build(),
                ColumnDTO.builder().originColumn("EUAPPROVALDATE").desColumn("EUAPPROVALDATE").build(),
                ColumnDTO.builder().originColumn("CLUTCHVENDOR").desColumn("CLUTCHVENDOR").build());
        String tableName = TableEnum.DC_RTYPE1_V_DAG_DCPC.getName();
        String dataBaseName = TableEnum.DC_RTYPE1_V_DAG_DCPC.getDataBaseName();
        return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from dc_rtype1_v").desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO dc_rtype1_v_dcex_dcex() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("WHC").desColumn("WHC").build(),
                ColumnDTO.builder().originColumn("CHASSBM").desColumn("CHASSBM").build(),
                ColumnDTO.builder().originColumn("CHASS_IDENT").desColumn("CHASS_IDENT").build(),
                ColumnDTO.builder().originColumn("VEHICLE_CATEGORY").desColumn("VEHICLE_CATEGORY").build(),
                ColumnDTO.builder().originColumn("ENGINE").desColumn("ENGINE").build(),
                ColumnDTO.builder().originColumn("TRANSMISSION").desColumn("TRANSMISSION").build(),
                ColumnDTO.builder().originColumn("STEERING").desColumn("STEERING").build(),
                ColumnDTO.builder().originColumn("BODY").desColumn("BODY").build(),
                ColumnDTO.builder().originColumn("FRONT_AXLE1").desColumn("FRONT_AXLE1").build(),
                ColumnDTO.builder().originColumn("FRONT_AXLE2").desColumn("FRONT_AXLE2").build(),
                ColumnDTO.builder().originColumn("REAR_AXLE1").desColumn("REAR_AXLE1").build(),
                ColumnDTO.builder().originColumn("REAR_AXLE2").desColumn("REAR_AXLE2").build(),
                ColumnDTO.builder().originColumn("TRANSFER_CASE").desColumn("TRANSFER_CASE").build(),
                ColumnDTO.builder().originColumn("PLATFORM").desColumn("PLATFORM").build(),
                ColumnDTO.builder().originColumn("BODY_CODE").desColumn("BODY_CODE").build(),
                ColumnDTO.builder().originColumn("MODEL_IDX").desColumn("MODEL_IDX").build(),
                ColumnDTO.builder().originColumn("ORDER_NUM1").desColumn("ORDER_NUM1").build(),
                ColumnDTO.builder().originColumn("PRODUCTION_NUM1").desColumn("PRODUCTION_NUM1").build(),
                ColumnDTO.builder().originColumn("AUXILIARY_DRIVE").desColumn("AUXILIARY_DRIVE").build(),
                ColumnDTO.builder().originColumn("HEATER").desColumn("HEATER").build(),
                ColumnDTO.builder().originColumn("RIMS").desColumn("RIMS").build(),
                ColumnDTO.builder().originColumn("LIGHTS").desColumn("LIGHTS").build(),
                ColumnDTO.builder().originColumn("WIPER").desColumn("WIPER").build(),
                ColumnDTO.builder().originColumn("WINCH").desColumn("WINCH").build(),
                ColumnDTO.builder().originColumn("ODOMETER").desColumn("ODOMETER").build(),
                ColumnDTO.builder().originColumn("VINWHC").desColumn("VINWHC").build(),
                ColumnDTO.builder().originColumn("VIN").desColumn("VIN").build(),
                ColumnDTO.builder().originColumn("TRAILER").desColumn("TRAILER").build(),
                ColumnDTO.builder().originColumn("INTERIOR").desColumn("INTERIOR").build(),
                ColumnDTO.builder().originColumn("PAINT1").desColumn("PAINT1").build(),
                ColumnDTO.builder().originColumn("PAINT2").desColumn("PAINT2").build(),
                ColumnDTO.builder().originColumn("PAINT3").desColumn("PAINT3").build(),
                ColumnDTO.builder().originColumn("PAINT4").desColumn("PAINT4").build(),
                ColumnDTO.builder().originColumn("PAINT5").desColumn("PAINT5").build(),
                ColumnDTO.builder().originColumn("RETARDER").desColumn("RETARDER").build(),
                ColumnDTO.builder().originColumn("DELIVERY_DATE").desColumn("DELIVERY_DATE").build(),
                ColumnDTO.builder().originColumn("PRODUCTION_ORDER_REF").desColumn("PRODUCTION_ORDER_REF").build(),
                ColumnDTO.builder().originColumn("SERVICE_NUM").desColumn("SERVICE_NUM").build(),
                ColumnDTO.builder().originColumn("RELEASE_DATE").desColumn("RELEASE_DATE").build(),
                ColumnDTO.builder().originColumn("LEADINGAGGREGATE").desColumn("LEADINGAGGREGATE").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE1").desColumn("ELECTRICALENGINE1").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE2").desColumn("ELECTRICALENGINE2").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE3").desColumn("ELECTRICALENGINE3").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE4").desColumn("ELECTRICALENGINE4").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE5").desColumn("ELECTRICALENGINE5").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE6").desColumn("ELECTRICALENGINE6").build(),
                ColumnDTO.builder().originColumn("HVBATTERY1").desColumn("HVBATTERY1").build(),
                ColumnDTO.builder().originColumn("HVBATTERY2").desColumn("HVBATTERY2").build(),
                ColumnDTO.builder().originColumn("HVBATTERY3").desColumn("HVBATTERY3").build(),
                ColumnDTO.builder().originColumn("FUELCELL1").desColumn("FUELCELL1").build(),
                ColumnDTO.builder().originColumn("FUELCELL2").desColumn("FUELCELL2").build(),
                ColumnDTO.builder().originColumn("FUELCELL3").desColumn("FUELCELL3").build(),
                ColumnDTO.builder().originColumn("EXHAUSTSYS").desColumn("EXHAUSTSYS").build(),
                ColumnDTO.builder().originColumn("FRONTAXLE3").desColumn("FRONTAXLE3").build(),
                ColumnDTO.builder().originColumn("REARAXLE3").desColumn("REARAXLE3").build(),
                ColumnDTO.builder().originColumn("REARAXLE4").desColumn("REARAXLE4").build(),
                ColumnDTO.builder().originColumn("EUAPPROVALNUM").desColumn("EUAPPROVALNUM").build(),
                ColumnDTO.builder().originColumn("EUAPPROVALDATE").desColumn("EUAPPROVALDATE").build(),
                ColumnDTO.builder().originColumn("CLUTCHVENDOR").desColumn("CLUTCHVENDOR").build());
        String tableName = TableEnum.DC_RTYPE1_V_DCEX_DCEX.getName();
        String dataBaseName = TableEnum.DC_RTYPE1_V_DCEX_DCEX.getDataBaseName();
        return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from dc_rtype1_v").desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO dc_rtype1_v_mbja_dcja() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("WHC").desColumn("WHC").build(),
                ColumnDTO.builder().originColumn("CHASSBM").desColumn("CHASSBM").build(),
                ColumnDTO.builder().originColumn("CHASS_IDENT").desColumn("CHASS_IDENT").build(),
                ColumnDTO.builder().originColumn("VEHICLE_CATEGORY").desColumn("VEHICLE_CATEGORY").build(),
                ColumnDTO.builder().originColumn("ENGINE").desColumn("ENGINE").build(),
                ColumnDTO.builder().originColumn("TRANSMISSION").desColumn("TRANSMISSION").build(),
                ColumnDTO.builder().originColumn("STEERING").desColumn("STEERING").build(),
                ColumnDTO.builder().originColumn("BODY").desColumn("BODY").build(),
                ColumnDTO.builder().originColumn("FRONT_AXLE1").desColumn("FRONT_AXLE1").build(),
                ColumnDTO.builder().originColumn("FRONT_AXLE2").desColumn("FRONT_AXLE2").build(),
                ColumnDTO.builder().originColumn("REAR_AXLE1").desColumn("REAR_AXLE1").build(),
                ColumnDTO.builder().originColumn("REAR_AXLE2").desColumn("REAR_AXLE2").build(),
                ColumnDTO.builder().originColumn("TRANSFER_CASE").desColumn("TRANSFER_CASE").build(),
                ColumnDTO.builder().originColumn("PLATFORM").desColumn("PLATFORM").build(),
                ColumnDTO.builder().originColumn("BODY_CODE").desColumn("BODY_CODE").build(),
                ColumnDTO.builder().originColumn("MODEL_IDX").desColumn("MODEL_IDX").build(),
                ColumnDTO.builder().originColumn("ORDER_NUM1").desColumn("ORDER_NUM1").build(),
                ColumnDTO.builder().originColumn("PRODUCTION_NUM1").desColumn("PRODUCTION_NUM1").build(),
                ColumnDTO.builder().originColumn("AUXILIARY_DRIVE").desColumn("AUXILIARY_DRIVE").build(),
                ColumnDTO.builder().originColumn("HEATER").desColumn("HEATER").build(),
                ColumnDTO.builder().originColumn("RIMS").desColumn("RIMS").build(),
                ColumnDTO.builder().originColumn("LIGHTS").desColumn("LIGHTS").build(),
                ColumnDTO.builder().originColumn("WIPER").desColumn("WIPER").build(),
                ColumnDTO.builder().originColumn("WINCH").desColumn("WINCH").build(),
                ColumnDTO.builder().originColumn("ODOMETER").desColumn("ODOMETER").build(),
                ColumnDTO.builder().originColumn("VINWHC").desColumn("VINWHC").build(),
                ColumnDTO.builder().originColumn("VIN").desColumn("VIN").build(),
                ColumnDTO.builder().originColumn("TRAILER").desColumn("TRAILER").build(),
                ColumnDTO.builder().originColumn("INTERIOR").desColumn("INTERIOR").build(),
                ColumnDTO.builder().originColumn("PAINT1").desColumn("PAINT1").build(),
                ColumnDTO.builder().originColumn("PAINT2").desColumn("PAINT2").build(),
                ColumnDTO.builder().originColumn("PAINT3").desColumn("PAINT3").build(),
                ColumnDTO.builder().originColumn("PAINT4").desColumn("PAINT4").build(),
                ColumnDTO.builder().originColumn("PAINT5").desColumn("PAINT5").build(),
                ColumnDTO.builder().originColumn("RETARDER").desColumn("RETARDER").build(),
                ColumnDTO.builder().originColumn("DELIVERY_DATE").desColumn("DELIVERY_DATE").build(),
                ColumnDTO.builder().originColumn("PRODUCTION_ORDER_REF").desColumn("PRODUCTION_ORDER_REF").build(),
                ColumnDTO.builder().originColumn("SERVICE_NUM").desColumn("SERVICE_NUM").build(),
                ColumnDTO.builder().originColumn("RELEASE_DATE").desColumn("RELEASE_DATE").build(),
                ColumnDTO.builder().originColumn("LEADINGAGGREGATE").desColumn("LEADINGAGGREGATE").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE1").desColumn("ELECTRICALENGINE1").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE2").desColumn("ELECTRICALENGINE2").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE3").desColumn("ELECTRICALENGINE3").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE4").desColumn("ELECTRICALENGINE4").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE5").desColumn("ELECTRICALENGINE5").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE6").desColumn("ELECTRICALENGINE6").build(),
                ColumnDTO.builder().originColumn("HVBATTERY1").desColumn("HVBATTERY1").build(),
                ColumnDTO.builder().originColumn("HVBATTERY2").desColumn("HVBATTERY2").build(),
                ColumnDTO.builder().originColumn("HVBATTERY3").desColumn("HVBATTERY3").build(),
                ColumnDTO.builder().originColumn("FUELCELL1").desColumn("FUELCELL1").build(),
                ColumnDTO.builder().originColumn("FUELCELL2").desColumn("FUELCELL2").build(),
                ColumnDTO.builder().originColumn("FUELCELL3").desColumn("FUELCELL3").build(),
                ColumnDTO.builder().originColumn("EXHAUSTSYS").desColumn("EXHAUSTSYS").build(),
                ColumnDTO.builder().originColumn("FRONTAXLE3").desColumn("FRONTAXLE3").build(),
                ColumnDTO.builder().originColumn("REARAXLE3").desColumn("REARAXLE3").build(),
                ColumnDTO.builder().originColumn("REARAXLE4").desColumn("REARAXLE4").build(),
                ColumnDTO.builder().originColumn("EUAPPROVALNUM").desColumn("EUAPPROVALNUM").build(),
                ColumnDTO.builder().originColumn("EUAPPROVALDATE").desColumn("EUAPPROVALDATE").build(),
                ColumnDTO.builder().originColumn("CLUTCHVENDOR").desColumn("CLUTCHVENDOR").build());
        String tableName = TableEnum.DC_RTYPE1_V_MBJA_DCJA.getName();
        String dataBaseName = TableEnum.DC_RTYPE1_V_MBJA_DCJA.getDataBaseName();
        return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from dc_rtype1_v").desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO dc_rtype1_v_mbla_dcla() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("WHC").desColumn("WHC").build(),
                ColumnDTO.builder().originColumn("CHASSBM").desColumn("CHASSBM").build(),
                ColumnDTO.builder().originColumn("CHASS_IDENT").desColumn("CHASS_IDENT").build(),
                ColumnDTO.builder().originColumn("VEHICLE_CATEGORY").desColumn("VEHICLE_CATEGORY").build(),
                ColumnDTO.builder().originColumn("ENGINE").desColumn("ENGINE").build(),
                ColumnDTO.builder().originColumn("TRANSMISSION").desColumn("TRANSMISSION").build(),
                ColumnDTO.builder().originColumn("STEERING").desColumn("STEERING").build(),
                ColumnDTO.builder().originColumn("BODY").desColumn("BODY").build(),
                ColumnDTO.builder().originColumn("FRONT_AXLE1").desColumn("FRONT_AXLE1").build(),
                ColumnDTO.builder().originColumn("FRONT_AXLE2").desColumn("FRONT_AXLE2").build(),
                ColumnDTO.builder().originColumn("REAR_AXLE1").desColumn("REAR_AXLE1").build(),
                ColumnDTO.builder().originColumn("REAR_AXLE2").desColumn("REAR_AXLE2").build(),
                ColumnDTO.builder().originColumn("TRANSFER_CASE").desColumn("TRANSFER_CASE").build(),
                ColumnDTO.builder().originColumn("PLATFORM").desColumn("PLATFORM").build(),
                ColumnDTO.builder().originColumn("BODY_CODE").desColumn("BODY_CODE").build(),
                ColumnDTO.builder().originColumn("MODEL_IDX").desColumn("MODEL_IDX").build(),
                ColumnDTO.builder().originColumn("ORDER_NUM1").desColumn("ORDER_NUM1").build(),
                ColumnDTO.builder().originColumn("PRODUCTION_NUM1").desColumn("PRODUCTION_NUM1").build(),
                ColumnDTO.builder().originColumn("AUXILIARY_DRIVE").desColumn("AUXILIARY_DRIVE").build(),
                ColumnDTO.builder().originColumn("HEATER").desColumn("HEATER").build(),
                ColumnDTO.builder().originColumn("RIMS").desColumn("RIMS").build(),
                ColumnDTO.builder().originColumn("LIGHTS").desColumn("LIGHTS").build(),
                ColumnDTO.builder().originColumn("WIPER").desColumn("WIPER").build(),
                ColumnDTO.builder().originColumn("WINCH").desColumn("WINCH").build(),
                ColumnDTO.builder().originColumn("ODOMETER").desColumn("ODOMETER").build(),
                ColumnDTO.builder().originColumn("VINWHC").desColumn("VINWHC").build(),
                ColumnDTO.builder().originColumn("VIN").desColumn("VIN").build(),
                ColumnDTO.builder().originColumn("TRAILER").desColumn("TRAILER").build(),
                ColumnDTO.builder().originColumn("INTERIOR").desColumn("INTERIOR").build(),
                ColumnDTO.builder().originColumn("PAINT1").desColumn("PAINT1").build(),
                ColumnDTO.builder().originColumn("PAINT2").desColumn("PAINT2").build(),
                ColumnDTO.builder().originColumn("PAINT3").desColumn("PAINT3").build(),
                ColumnDTO.builder().originColumn("PAINT4").desColumn("PAINT4").build(),
                ColumnDTO.builder().originColumn("PAINT5").desColumn("PAINT5").build(),
                ColumnDTO.builder().originColumn("RETARDER").desColumn("RETARDER").build(),
                ColumnDTO.builder().originColumn("DELIVERY_DATE").desColumn("DELIVERY_DATE").build(),
                ColumnDTO.builder().originColumn("PRODUCTION_ORDER_REF").desColumn("PRODUCTION_ORDER_REF").build(),
                ColumnDTO.builder().originColumn("SERVICE_NUM").desColumn("SERVICE_NUM").build(),
                ColumnDTO.builder().originColumn("RELEASE_DATE").desColumn("RELEASE_DATE").build(),
                ColumnDTO.builder().originColumn("LEADINGAGGREGATE").desColumn("LEADINGAGGREGATE").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE1").desColumn("ELECTRICALENGINE1").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE2").desColumn("ELECTRICALENGINE2").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE3").desColumn("ELECTRICALENGINE3").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE4").desColumn("ELECTRICALENGINE4").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE5").desColumn("ELECTRICALENGINE5").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE6").desColumn("ELECTRICALENGINE6").build(),
                ColumnDTO.builder().originColumn("HVBATTERY1").desColumn("HVBATTERY1").build(),
                ColumnDTO.builder().originColumn("HVBATTERY2").desColumn("HVBATTERY2").build(),
                ColumnDTO.builder().originColumn("HVBATTERY3").desColumn("HVBATTERY3").build(),
                ColumnDTO.builder().originColumn("FUELCELL1").desColumn("FUELCELL1").build(),
                ColumnDTO.builder().originColumn("FUELCELL2").desColumn("FUELCELL2").build(),
                ColumnDTO.builder().originColumn("FUELCELL3").desColumn("FUELCELL3").build(),
                ColumnDTO.builder().originColumn("EXHAUSTSYS").desColumn("EXHAUSTSYS").build(),
                ColumnDTO.builder().originColumn("FRONTAXLE3").desColumn("FRONTAXLE3").build(),
                ColumnDTO.builder().originColumn("REARAXLE3").desColumn("REARAXLE3").build(),
                ColumnDTO.builder().originColumn("REARAXLE4").desColumn("REARAXLE4").build(),
                ColumnDTO.builder().originColumn("EUAPPROVALNUM").desColumn("EUAPPROVALNUM").build(),
                ColumnDTO.builder().originColumn("EUAPPROVALDATE").desColumn("EUAPPROVALDATE").build(),
                ColumnDTO.builder().originColumn("CLUTCHVENDOR").desColumn("CLUTCHVENDOR").build());
        String tableName = TableEnum.DC_RTYPE1_V_MBLA_DCLA.getName();
        String dataBaseName = TableEnum.DC_RTYPE1_V_MBLA_DCLA.getDataBaseName();
        return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from dc_rtype1_v").desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO dc_rtype1_v_mbna_dcna() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("WHC").desColumn("WHC").build(),
                ColumnDTO.builder().originColumn("CHASSBM").desColumn("CHASSBM").build(),
                ColumnDTO.builder().originColumn("CHASS_IDENT").desColumn("CHASS_IDENT").build(),
                ColumnDTO.builder().originColumn("VEHICLE_CATEGORY").desColumn("VEHICLE_CATEGORY").build(),
                ColumnDTO.builder().originColumn("ENGINE").desColumn("ENGINE").build(),
                ColumnDTO.builder().originColumn("TRANSMISSION").desColumn("TRANSMISSION").build(),
                ColumnDTO.builder().originColumn("STEERING").desColumn("STEERING").build(),
                ColumnDTO.builder().originColumn("BODY").desColumn("BODY").build(),
                ColumnDTO.builder().originColumn("FRONT_AXLE1").desColumn("FRONT_AXLE1").build(),
                ColumnDTO.builder().originColumn("FRONT_AXLE2").desColumn("FRONT_AXLE2").build(),
                ColumnDTO.builder().originColumn("REAR_AXLE1").desColumn("REAR_AXLE1").build(),
                ColumnDTO.builder().originColumn("REAR_AXLE2").desColumn("REAR_AXLE2").build(),
                ColumnDTO.builder().originColumn("TRANSFER_CASE").desColumn("TRANSFER_CASE").build(),
                ColumnDTO.builder().originColumn("PLATFORM").desColumn("PLATFORM").build(),
                ColumnDTO.builder().originColumn("BODY_CODE").desColumn("BODY_CODE").build(),
                ColumnDTO.builder().originColumn("MODEL_IDX").desColumn("MODEL_IDX").build(),
                ColumnDTO.builder().originColumn("ORDER_NUM1").desColumn("ORDER_NUM1").build(),
                ColumnDTO.builder().originColumn("PRODUCTION_NUM1").desColumn("PRODUCTION_NUM1").build(),
                ColumnDTO.builder().originColumn("AUXILIARY_DRIVE").desColumn("AUXILIARY_DRIVE").build(),
                ColumnDTO.builder().originColumn("HEATER").desColumn("HEATER").build(),
                ColumnDTO.builder().originColumn("RIMS").desColumn("RIMS").build(),
                ColumnDTO.builder().originColumn("LIGHTS").desColumn("LIGHTS").build(),
                ColumnDTO.builder().originColumn("WIPER").desColumn("WIPER").build(),
                ColumnDTO.builder().originColumn("WINCH").desColumn("WINCH").build(),
                ColumnDTO.builder().originColumn("ODOMETER").desColumn("ODOMETER").build(),
                ColumnDTO.builder().originColumn("VINWHC").desColumn("VINWHC").build(),
                ColumnDTO.builder().originColumn("VIN").desColumn("VIN").build(),
                ColumnDTO.builder().originColumn("TRAILER").desColumn("TRAILER").build(),
                ColumnDTO.builder().originColumn("INTERIOR").desColumn("INTERIOR").build(),
                ColumnDTO.builder().originColumn("PAINT1").desColumn("PAINT1").build(),
                ColumnDTO.builder().originColumn("PAINT2").desColumn("PAINT2").build(),
                ColumnDTO.builder().originColumn("PAINT3").desColumn("PAINT3").build(),
                ColumnDTO.builder().originColumn("PAINT4").desColumn("PAINT4").build(),
                ColumnDTO.builder().originColumn("PAINT5").desColumn("PAINT5").build(),
                ColumnDTO.builder().originColumn("RETARDER").desColumn("RETARDER").build(),
                ColumnDTO.builder().originColumn("DELIVERY_DATE").desColumn("DELIVERY_DATE").build(),
                ColumnDTO.builder().originColumn("PRODUCTION_ORDER_REF").desColumn("PRODUCTION_ORDER_REF").build(),
                ColumnDTO.builder().originColumn("SERVICE_NUM").desColumn("SERVICE_NUM").build(),
                ColumnDTO.builder().originColumn("RELEASE_DATE").desColumn("RELEASE_DATE").build(),
                ColumnDTO.builder().originColumn("LEADINGAGGREGATE").desColumn("LEADINGAGGREGATE").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE1").desColumn("ELECTRICALENGINE1").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE2").desColumn("ELECTRICALENGINE2").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE3").desColumn("ELECTRICALENGINE3").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE4").desColumn("ELECTRICALENGINE4").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE5").desColumn("ELECTRICALENGINE5").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE6").desColumn("ELECTRICALENGINE6").build(),
                ColumnDTO.builder().originColumn("HVBATTERY1").desColumn("HVBATTERY1").build(),
                ColumnDTO.builder().originColumn("HVBATTERY2").desColumn("HVBATTERY2").build(),
                ColumnDTO.builder().originColumn("HVBATTERY3").desColumn("HVBATTERY3").build(),
                ColumnDTO.builder().originColumn("FUELCELL1").desColumn("FUELCELL1").build(),
                ColumnDTO.builder().originColumn("FUELCELL2").desColumn("FUELCELL2").build(),
                ColumnDTO.builder().originColumn("FUELCELL3").desColumn("FUELCELL3").build(),
                ColumnDTO.builder().originColumn("EXHAUSTSYS").desColumn("EXHAUSTSYS").build(),
                ColumnDTO.builder().originColumn("FRONTAXLE3").desColumn("FRONTAXLE3").build(),
                ColumnDTO.builder().originColumn("REARAXLE3").desColumn("REARAXLE3").build(),
                ColumnDTO.builder().originColumn("REARAXLE4").desColumn("REARAXLE4").build(),
                ColumnDTO.builder().originColumn("EUAPPROVALNUM").desColumn("EUAPPROVALNUM").build(),
                ColumnDTO.builder().originColumn("EUAPPROVALDATE").desColumn("EUAPPROVALDATE").build(),
                ColumnDTO.builder().originColumn("CLUTCHVENDOR").desColumn("CLUTCHVENDOR").build());
        String tableName = TableEnum.DC_RTYPE1_V_MBNA_DCNA.getName();
        String dataBaseName = TableEnum.DC_RTYPE1_V_MBNA_DCNA.getDataBaseName();
        return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from dc_rtype1_v").desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO dc_rtype1_v_mboe_dccar() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("WHC").desColumn("WHC").build(),
                ColumnDTO.builder().originColumn("CHASSBM").desColumn("CHASSBM").build(),
                ColumnDTO.builder().originColumn("CHASS_IDENT").desColumn("CHASS_IDENT").build(),
                ColumnDTO.builder().originColumn("VEHICLE_CATEGORY").desColumn("VEHICLE_CATEGORY").build(),
                ColumnDTO.builder().originColumn("ENGINE").desColumn("ENGINE").build(),
                ColumnDTO.builder().originColumn("TRANSMISSION").desColumn("TRANSMISSION").build(),
                ColumnDTO.builder().originColumn("STEERING").desColumn("STEERING").build(),
                ColumnDTO.builder().originColumn("BODY").desColumn("BODY").build(),
                ColumnDTO.builder().originColumn("FRONT_AXLE1").desColumn("FRONT_AXLE1").build(),
                ColumnDTO.builder().originColumn("FRONT_AXLE2").desColumn("FRONT_AXLE2").build(),
                ColumnDTO.builder().originColumn("REAR_AXLE1").desColumn("REAR_AXLE1").build(),
                ColumnDTO.builder().originColumn("REAR_AXLE2").desColumn("REAR_AXLE2").build(),
                ColumnDTO.builder().originColumn("TRANSFER_CASE").desColumn("TRANSFER_CASE").build(),
                ColumnDTO.builder().originColumn("PLATFORM").desColumn("PLATFORM").build(),
                ColumnDTO.builder().originColumn("BODY_CODE").desColumn("BODY_CODE").build(),
                ColumnDTO.builder().originColumn("MODEL_IDX").desColumn("MODEL_IDX").build(),
                ColumnDTO.builder().originColumn("ORDER_NUM1").desColumn("ORDER_NUM1").build(),
                ColumnDTO.builder().originColumn("PRODUCTION_NUM1").desColumn("PRODUCTION_NUM1").build(),
                ColumnDTO.builder().originColumn("AUXILIARY_DRIVE").desColumn("AUXILIARY_DRIVE").build(),
                ColumnDTO.builder().originColumn("HEATER").desColumn("HEATER").build(),
                ColumnDTO.builder().originColumn("RIMS").desColumn("RIMS").build(),
                ColumnDTO.builder().originColumn("LIGHTS").desColumn("LIGHTS").build(),
                ColumnDTO.builder().originColumn("WIPER").desColumn("WIPER").build(),
                ColumnDTO.builder().originColumn("WINCH").desColumn("WINCH").build(),
                ColumnDTO.builder().originColumn("ODOMETER").desColumn("ODOMETER").build(),
                ColumnDTO.builder().originColumn("VINWHC").desColumn("VINWHC").build(),
                ColumnDTO.builder().originColumn("VIN").desColumn("VIN").build(),
                ColumnDTO.builder().originColumn("TRAILER").desColumn("TRAILER").build(),
                ColumnDTO.builder().originColumn("INTERIOR").desColumn("INTERIOR").build(),
                ColumnDTO.builder().originColumn("PAINT1").desColumn("PAINT1").build(),
                ColumnDTO.builder().originColumn("PAINT2").desColumn("PAINT2").build(),
                ColumnDTO.builder().originColumn("PAINT3").desColumn("PAINT3").build(),
                ColumnDTO.builder().originColumn("PAINT4").desColumn("PAINT4").build(),
                ColumnDTO.builder().originColumn("PAINT5").desColumn("PAINT5").build(),
                ColumnDTO.builder().originColumn("RETARDER").desColumn("RETARDER").build(),
                ColumnDTO.builder().originColumn("DELIVERY_DATE").desColumn("DELIVERY_DATE").build(),
                ColumnDTO.builder().originColumn("PRODUCTION_ORDER_REF").desColumn("PRODUCTION_ORDER_REF").build(),
                ColumnDTO.builder().originColumn("SERVICE_NUM").desColumn("SERVICE_NUM").build(),
                ColumnDTO.builder().originColumn("RELEASE_DATE").desColumn("RELEASE_DATE").build(),
                ColumnDTO.builder().originColumn("LEADINGAGGREGATE").desColumn("LEADINGAGGREGATE").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE1").desColumn("ELECTRICALENGINE1").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE2").desColumn("ELECTRICALENGINE2").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE3").desColumn("ELECTRICALENGINE3").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE4").desColumn("ELECTRICALENGINE4").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE5").desColumn("ELECTRICALENGINE5").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE6").desColumn("ELECTRICALENGINE6").build(),
                ColumnDTO.builder().originColumn("HVBATTERY1").desColumn("HVBATTERY1").build(),
                ColumnDTO.builder().originColumn("HVBATTERY2").desColumn("HVBATTERY2").build(),
                ColumnDTO.builder().originColumn("HVBATTERY3").desColumn("HVBATTERY3").build(),
                ColumnDTO.builder().originColumn("FUELCELL1").desColumn("FUELCELL1").build(),
                ColumnDTO.builder().originColumn("FUELCELL2").desColumn("FUELCELL2").build(),
                ColumnDTO.builder().originColumn("FUELCELL3").desColumn("FUELCELL3").build(),
                ColumnDTO.builder().originColumn("EXHAUSTSYS").desColumn("EXHAUSTSYS").build(),
                ColumnDTO.builder().originColumn("FRONTAXLE3").desColumn("FRONTAXLE3").build(),
                ColumnDTO.builder().originColumn("REARAXLE3").desColumn("REARAXLE3").build(),
                ColumnDTO.builder().originColumn("REARAXLE4").desColumn("REARAXLE4").build(),
                ColumnDTO.builder().originColumn("EUAPPROVALNUM").desColumn("EUAPPROVALNUM").build(),
                ColumnDTO.builder().originColumn("EUAPPROVALDATE").desColumn("EUAPPROVALDATE").build(),
                ColumnDTO.builder().originColumn("CLUTCHVENDOR").desColumn("CLUTCHVENDOR").build());
        String tableName = TableEnum.DC_RTYPE1_V_MBOE_DCCAR.getName();
        String dataBaseName = TableEnum.DC_RTYPE1_V_MBOE_DCCAR.getDataBaseName();
        return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from dc_rtype1_v").desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO dc_rtype1_v_mboe_dcgwgn() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("WHC").desColumn("WHC").build(),
                ColumnDTO.builder().originColumn("CHASSBM").desColumn("CHASSBM").build(),
                ColumnDTO.builder().originColumn("CHASS_IDENT").desColumn("CHASS_IDENT").build(),
                ColumnDTO.builder().originColumn("VEHICLE_CATEGORY").desColumn("VEHICLE_CATEGORY").build(),
                ColumnDTO.builder().originColumn("ENGINE").desColumn("ENGINE").build(),
                ColumnDTO.builder().originColumn("TRANSMISSION").desColumn("TRANSMISSION").build(),
                ColumnDTO.builder().originColumn("STEERING").desColumn("STEERING").build(),
                ColumnDTO.builder().originColumn("BODY").desColumn("BODY").build(),
                ColumnDTO.builder().originColumn("FRONT_AXLE1").desColumn("FRONT_AXLE1").build(),
                ColumnDTO.builder().originColumn("FRONT_AXLE2").desColumn("FRONT_AXLE2").build(),
                ColumnDTO.builder().originColumn("REAR_AXLE1").desColumn("REAR_AXLE1").build(),
                ColumnDTO.builder().originColumn("REAR_AXLE2").desColumn("REAR_AXLE2").build(),
                ColumnDTO.builder().originColumn("TRANSFER_CASE").desColumn("TRANSFER_CASE").build(),
                ColumnDTO.builder().originColumn("PLATFORM").desColumn("PLATFORM").build(),
                ColumnDTO.builder().originColumn("BODY_CODE").desColumn("BODY_CODE").build(),
                ColumnDTO.builder().originColumn("MODEL_IDX").desColumn("MODEL_IDX").build(),
                ColumnDTO.builder().originColumn("ORDER_NUM1").desColumn("ORDER_NUM1").build(),
                ColumnDTO.builder().originColumn("PRODUCTION_NUM1").desColumn("PRODUCTION_NUM1").build(),
                ColumnDTO.builder().originColumn("AUXILIARY_DRIVE").desColumn("AUXILIARY_DRIVE").build(),
                ColumnDTO.builder().originColumn("HEATER").desColumn("HEATER").build(),
                ColumnDTO.builder().originColumn("RIMS").desColumn("RIMS").build(),
                ColumnDTO.builder().originColumn("LIGHTS").desColumn("LIGHTS").build(),
                ColumnDTO.builder().originColumn("WIPER").desColumn("WIPER").build(),
                ColumnDTO.builder().originColumn("WINCH").desColumn("WINCH").build(),
                ColumnDTO.builder().originColumn("ODOMETER").desColumn("ODOMETER").build(),
                ColumnDTO.builder().originColumn("VINWHC").desColumn("VINWHC").build(),
                ColumnDTO.builder().originColumn("VIN").desColumn("VIN").build(),
                ColumnDTO.builder().originColumn("TRAILER").desColumn("TRAILER").build(),
                ColumnDTO.builder().originColumn("INTERIOR").desColumn("INTERIOR").build(),
                ColumnDTO.builder().originColumn("PAINT1").desColumn("PAINT1").build(),
                ColumnDTO.builder().originColumn("PAINT2").desColumn("PAINT2").build(),
                ColumnDTO.builder().originColumn("PAINT3").desColumn("PAINT3").build(),
                ColumnDTO.builder().originColumn("PAINT4").desColumn("PAINT4").build(),
                ColumnDTO.builder().originColumn("PAINT5").desColumn("PAINT5").build(),
                ColumnDTO.builder().originColumn("RETARDER").desColumn("RETARDER").build(),
                ColumnDTO.builder().originColumn("DELIVERY_DATE").desColumn("DELIVERY_DATE").build(),
                ColumnDTO.builder().originColumn("PRODUCTION_ORDER_REF").desColumn("PRODUCTION_ORDER_REF").build(),
                ColumnDTO.builder().originColumn("SERVICE_NUM").desColumn("SERVICE_NUM").build(),
                ColumnDTO.builder().originColumn("RELEASE_DATE").desColumn("RELEASE_DATE").build(),
                ColumnDTO.builder().originColumn("LEADINGAGGREGATE").desColumn("LEADINGAGGREGATE").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE1").desColumn("ELECTRICALENGINE1").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE2").desColumn("ELECTRICALENGINE2").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE3").desColumn("ELECTRICALENGINE3").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE4").desColumn("ELECTRICALENGINE4").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE5").desColumn("ELECTRICALENGINE5").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE6").desColumn("ELECTRICALENGINE6").build(),
                ColumnDTO.builder().originColumn("HVBATTERY1").desColumn("HVBATTERY1").build(),
                ColumnDTO.builder().originColumn("HVBATTERY2").desColumn("HVBATTERY2").build(),
                ColumnDTO.builder().originColumn("HVBATTERY3").desColumn("HVBATTERY3").build(),
                ColumnDTO.builder().originColumn("FUELCELL1").desColumn("FUELCELL1").build(),
                ColumnDTO.builder().originColumn("FUELCELL2").desColumn("FUELCELL2").build(),
                ColumnDTO.builder().originColumn("FUELCELL3").desColumn("FUELCELL3").build(),
                ColumnDTO.builder().originColumn("EXHAUSTSYS").desColumn("EXHAUSTSYS").build(),
                ColumnDTO.builder().originColumn("FRONTAXLE3").desColumn("FRONTAXLE3").build(),
                ColumnDTO.builder().originColumn("REARAXLE3").desColumn("REARAXLE3").build(),
                ColumnDTO.builder().originColumn("REARAXLE4").desColumn("REARAXLE4").build(),
                ColumnDTO.builder().originColumn("EUAPPROVALNUM").desColumn("EUAPPROVALNUM").build(),
                ColumnDTO.builder().originColumn("EUAPPROVALDATE").desColumn("EUAPPROVALDATE").build(),
                ColumnDTO.builder().originColumn("CLUTCHVENDOR").desColumn("CLUTCHVENDOR").build());
        String tableName = TableEnum.DC_RTYPE1_V_MBOE_DCGWGN.getName();
        String dataBaseName = TableEnum.DC_RTYPE1_V_MBOE_DCGWGN.getDataBaseName();
        return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from dc_rtype1_v").desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO dc_rtype1_v_mbsm_dcsm() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("WHC").desColumn("WHC").build(),
                ColumnDTO.builder().originColumn("CHASSBM").desColumn("CHASSBM").build(),
                ColumnDTO.builder().originColumn("CHASS_IDENT").desColumn("CHASS_IDENT").build(),
                ColumnDTO.builder().originColumn("VEHICLE_CATEGORY").desColumn("VEHICLE_CATEGORY").build(),
                ColumnDTO.builder().originColumn("ENGINE").desColumn("ENGINE").build(),
                ColumnDTO.builder().originColumn("TRANSMISSION").desColumn("TRANSMISSION").build(),
                ColumnDTO.builder().originColumn("STEERING").desColumn("STEERING").build(),
                ColumnDTO.builder().originColumn("BODY").desColumn("BODY").build(),
                ColumnDTO.builder().originColumn("FRONT_AXLE1").desColumn("FRONT_AXLE1").build(),
                ColumnDTO.builder().originColumn("FRONT_AXLE2").desColumn("FRONT_AXLE2").build(),
                ColumnDTO.builder().originColumn("REAR_AXLE1").desColumn("REAR_AXLE1").build(),
                ColumnDTO.builder().originColumn("REAR_AXLE2").desColumn("REAR_AXLE2").build(),
                ColumnDTO.builder().originColumn("TRANSFER_CASE").desColumn("TRANSFER_CASE").build(),
                ColumnDTO.builder().originColumn("PLATFORM").desColumn("PLATFORM").build(),
                ColumnDTO.builder().originColumn("BODY_CODE").desColumn("BODY_CODE").build(),
                ColumnDTO.builder().originColumn("MODEL_IDX").desColumn("MODEL_IDX").build(),
                ColumnDTO.builder().originColumn("ORDER_NUM1").desColumn("ORDER_NUM1").build(),
                ColumnDTO.builder().originColumn("PRODUCTION_NUM1").desColumn("PRODUCTION_NUM1").build(),
                ColumnDTO.builder().originColumn("AUXILIARY_DRIVE").desColumn("AUXILIARY_DRIVE").build(),
                ColumnDTO.builder().originColumn("HEATER").desColumn("HEATER").build(),
                ColumnDTO.builder().originColumn("RIMS").desColumn("RIMS").build(),
                ColumnDTO.builder().originColumn("LIGHTS").desColumn("LIGHTS").build(),
                ColumnDTO.builder().originColumn("WIPER").desColumn("WIPER").build(),
                ColumnDTO.builder().originColumn("WINCH").desColumn("WINCH").build(),
                ColumnDTO.builder().originColumn("ODOMETER").desColumn("ODOMETER").build(),
                ColumnDTO.builder().originColumn("VINWHC").desColumn("VINWHC").build(),
                ColumnDTO.builder().originColumn("VIN").desColumn("VIN").build(),
                ColumnDTO.builder().originColumn("TRAILER").desColumn("TRAILER").build(),
                ColumnDTO.builder().originColumn("INTERIOR").desColumn("INTERIOR").build(),
                ColumnDTO.builder().originColumn("PAINT1").desColumn("PAINT1").build(),
                ColumnDTO.builder().originColumn("PAINT2").desColumn("PAINT2").build(),
                ColumnDTO.builder().originColumn("PAINT3").desColumn("PAINT3").build(),
                ColumnDTO.builder().originColumn("PAINT4").desColumn("PAINT4").build(),
                ColumnDTO.builder().originColumn("PAINT5").desColumn("PAINT5").build(),
                ColumnDTO.builder().originColumn("RETARDER").desColumn("RETARDER").build(),
                ColumnDTO.builder().originColumn("DELIVERY_DATE").desColumn("DELIVERY_DATE").build(),
                ColumnDTO.builder().originColumn("PRODUCTION_ORDER_REF").desColumn("PRODUCTION_ORDER_REF").build(),
                ColumnDTO.builder().originColumn("SERVICE_NUM").desColumn("SERVICE_NUM").build(),
                ColumnDTO.builder().originColumn("RELEASE_DATE").desColumn("RELEASE_DATE").build(),
                ColumnDTO.builder().originColumn("LEADINGAGGREGATE").desColumn("LEADINGAGGREGATE").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE1").desColumn("ELECTRICALENGINE1").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE2").desColumn("ELECTRICALENGINE2").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE3").desColumn("ELECTRICALENGINE3").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE4").desColumn("ELECTRICALENGINE4").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE5").desColumn("ELECTRICALENGINE5").build(),
                ColumnDTO.builder().originColumn("ELECTRICALENGINE6").desColumn("ELECTRICALENGINE6").build(),
                ColumnDTO.builder().originColumn("HVBATTERY1").desColumn("HVBATTERY1").build(),
                ColumnDTO.builder().originColumn("HVBATTERY2").desColumn("HVBATTERY2").build(),
                ColumnDTO.builder().originColumn("HVBATTERY3").desColumn("HVBATTERY3").build(),
                ColumnDTO.builder().originColumn("FUELCELL1").desColumn("FUELCELL1").build(),
                ColumnDTO.builder().originColumn("FUELCELL2").desColumn("FUELCELL2").build(),
                ColumnDTO.builder().originColumn("FUELCELL3").desColumn("FUELCELL3").build(),
                ColumnDTO.builder().originColumn("EXHAUSTSYS").desColumn("EXHAUSTSYS").build(),
                ColumnDTO.builder().originColumn("FRONTAXLE3").desColumn("FRONTAXLE3").build(),
                ColumnDTO.builder().originColumn("REARAXLE3").desColumn("REARAXLE3").build(),
                ColumnDTO.builder().originColumn("REARAXLE4").desColumn("REARAXLE4").build(),
                ColumnDTO.builder().originColumn("EUAPPROVALNUM").desColumn("EUAPPROVALNUM").build(),
                ColumnDTO.builder().originColumn("EUAPPROVALDATE").desColumn("EUAPPROVALDATE").build(),
                ColumnDTO.builder().originColumn("CLUTCHVENDOR").desColumn("CLUTCHVENDOR").build());
        String tableName = TableEnum.DC_RTYPE1_V_MBSM_DCSM.getName();
        String dataBaseName = TableEnum.DC_RTYPE1_V_MBSM_DCSM.getDataBaseName();
        return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from dc_rtype1_v").desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO dc_rtype3_v_dag_dccv() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("WHC").desColumn("WHC").build(),
                ColumnDTO.builder().originColumn("CHASSBM").desColumn("CHASSBM").build(),
                ColumnDTO.builder().originColumn("CHASS_IDENT").desColumn("CHASS_IDENT").build(),
                ColumnDTO.builder().originColumn("SEQNUM").desColumn("SEQNUM").build(),
                ColumnDTO.builder().originColumn("SACODE_DATA").desColumn("SACODE_DATA").build());
        String tableName = TableEnum.DC_RTYPE3_V_DAG_DCCV.getName();
        String dataBaseName = TableEnum.DC_RTYPE3_V_DAG_DCCV.getDataBaseName();
        return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from dc_rtype3_v").desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO dc_rtype3_v_dag_dcpc() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("WHC").desColumn("WHC").build(),
                ColumnDTO.builder().originColumn("CHASSBM").desColumn("CHASSBM").build(),
                ColumnDTO.builder().originColumn("CHASS_IDENT").desColumn("CHASS_IDENT").build(),
                ColumnDTO.builder().originColumn("SEQNUM").desColumn("SEQNUM").build(),
                ColumnDTO.builder().originColumn("SACODE_DATA").desColumn("SACODE_DATA").build());
        String tableName = TableEnum.DC_RTYPE3_V_DAG_DCPC.getName();
        String dataBaseName = TableEnum.DC_RTYPE3_V_DAG_DCPC.getDataBaseName();
        return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from dc_rtype3_v").desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO dc_rtype3_v_dcex_dcex() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("WHC").desColumn("WHC").build(),
                ColumnDTO.builder().originColumn("CHASSBM").desColumn("CHASSBM").build(),
                ColumnDTO.builder().originColumn("CHASS_IDENT").desColumn("CHASS_IDENT").build(),
                ColumnDTO.builder().originColumn("SEQNUM").desColumn("SEQNUM").build(),
                ColumnDTO.builder().originColumn("SACODE_DATA").desColumn("SACODE_DATA").build());
        String tableName = TableEnum.DC_RTYPE3_V_DCEX_DCEX.getName();
        String dataBaseName = TableEnum.DC_RTYPE3_V_DCEX_DCEX.getDataBaseName();
        return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from dc_rtype3_v").desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO dc_rtype3_v_mbja_dcja() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("WHC").desColumn("WHC").build(),
                ColumnDTO.builder().originColumn("CHASSBM").desColumn("CHASSBM").build(),
                ColumnDTO.builder().originColumn("CHASS_IDENT").desColumn("CHASS_IDENT").build(),
                ColumnDTO.builder().originColumn("SEQNUM").desColumn("SEQNUM").build(),
                ColumnDTO.builder().originColumn("SACODE_DATA").desColumn("SACODE_DATA").build());
        String tableName = TableEnum.DC_RTYPE3_V_MBJA_DCJA.getName();
        String dataBaseName = TableEnum.DC_RTYPE3_V_MBJA_DCJA.getDataBaseName();
        return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from dc_rtype3_v").desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO dc_rtype3_v_mbla_dcla() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("WHC").desColumn("WHC").build(),
                ColumnDTO.builder().originColumn("CHASSBM").desColumn("CHASSBM").build(),
                ColumnDTO.builder().originColumn("CHASS_IDENT").desColumn("CHASS_IDENT").build(),
                ColumnDTO.builder().originColumn("SEQNUM").desColumn("SEQNUM").build(),
                ColumnDTO.builder().originColumn("SACODE_DATA").desColumn("SACODE_DATA").build());
        String tableName = TableEnum.DC_RTYPE3_V_MBLA_DCLA.getName();
        String dataBaseName = TableEnum.DC_RTYPE3_V_MBLA_DCLA.getDataBaseName();
        return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from dc_rtype3_v").desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO dc_rtype3_v_mbna_dcna() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("WHC").desColumn("WHC").build(),
                ColumnDTO.builder().originColumn("CHASSBM").desColumn("CHASSBM").build(),
                ColumnDTO.builder().originColumn("CHASS_IDENT").desColumn("CHASS_IDENT").build(),
                ColumnDTO.builder().originColumn("SEQNUM").desColumn("SEQNUM").build(),
                ColumnDTO.builder().originColumn("SACODE_DATA").desColumn("SACODE_DATA").build());
        String tableName = TableEnum.DC_RTYPE3_V_MBNA_DCNA.getName();
        String dataBaseName = TableEnum.DC_RTYPE3_V_MBNA_DCNA.getDataBaseName();
        return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from dc_rtype3_v").desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO dc_rtype3_v_mboe_dccar() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("WHC").desColumn("WHC").build(),
                ColumnDTO.builder().originColumn("CHASSBM").desColumn("CHASSBM").build(),
                ColumnDTO.builder().originColumn("CHASS_IDENT").desColumn("CHASS_IDENT").build(),
                ColumnDTO.builder().originColumn("SEQNUM").desColumn("SEQNUM").build(),
                ColumnDTO.builder().originColumn("SACODE_DATA").desColumn("SACODE_DATA").build());
        String tableName = TableEnum.DC_RTYPE3_V_MBOE_DCCAR.getName();
        String dataBaseName = TableEnum.DC_RTYPE3_V_MBOE_DCCAR.getDataBaseName();
        return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from dc_rtype3_v").desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO dc_rtype3_v_mboe_dcgwgn() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("WHC").desColumn("WHC").build(),
                ColumnDTO.builder().originColumn("CHASSBM").desColumn("CHASSBM").build(),
                ColumnDTO.builder().originColumn("CHASS_IDENT").desColumn("CHASS_IDENT").build(),
                ColumnDTO.builder().originColumn("SEQNUM").desColumn("SEQNUM").build(),
                ColumnDTO.builder().originColumn("SACODE_DATA").desColumn("SACODE_DATA").build());
        String tableName = TableEnum.DC_RTYPE3_V_MBOE_DCGWGN.getName();
        String dataBaseName = TableEnum.DC_RTYPE3_V_MBOE_DCGWGN.getDataBaseName();
        return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from dc_rtype3_v").desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO dc_rtype3_v_mbsm_dcsm() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("WHC").desColumn("WHC").build(),
                ColumnDTO.builder().originColumn("CHASSBM").desColumn("CHASSBM").build(),
                ColumnDTO.builder().originColumn("CHASS_IDENT").desColumn("CHASS_IDENT").build(),
                ColumnDTO.builder().originColumn("SEQNUM").desColumn("SEQNUM").build(),
                ColumnDTO.builder().originColumn("SACODE_DATA").desColumn("SACODE_DATA").build());
        String tableName = TableEnum.DC_RTYPE3_V_MBSM_DCSM.getName();
        String dataBaseName = TableEnum.DC_RTYPE3_V_MBSM_DCSM.getDataBaseName();
        return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from dc_rtype3_v").desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO models_v() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("CLASS").desColumn("CLASS").build(),
                ColumnDTO.builder().originColumn("AGGTYPE").desColumn("AGGTYPE").build(),
                ColumnDTO.builder().originColumn("APPINF").desColumn("APPINF").build(),
                ColumnDTO.builder().originColumn("TYPE").desColumn("TYPE").build(),
                ColumnDTO.builder().originColumn("SUBBM1").desColumn("SUBBM1").build(),
                ColumnDTO.builder().originColumn("SUBBM2").desColumn("SUBBM2").build(),
                ColumnDTO.builder().originColumn("CATNUM").desColumn("CATNUM").build(),
                ColumnDTO.builder().originColumn("SALESDES").desColumn("SALESDES").build(),
                ColumnDTO.builder().originColumn("DATEF").desColumn("DATEF").build(),
                ColumnDTO.builder().originColumn("CATTYP2").desColumn("CATTYP2").build(),
                ColumnDTO.builder().originColumn("SUBBM3").desColumn("SUBBM3").build(),
                ColumnDTO.builder().originColumn("SOURCE").desColumn("SOURCE").build(),
                ColumnDTO.builder().originColumn("DATET").desColumn("DATET").build(),
                ColumnDTO.builder().originColumn("REMARKS").desColumn("REMARKS").build(),
                ColumnDTO.builder().originColumn("CATTYPE").desColumn("CATTYPE").build(),
                ColumnDTO.builder().originColumn("MODELYR").desColumn("MODELYR").build());
        String tableName = TableEnum.MODELS_V.getName();
        String dataBaseName = TableEnum.MODELS_V.getDataBaseName();
        return TableDTO.builder().dataBaseName(dataBaseName).querySql("select * from "+tableName).desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO part_descs_v() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("DESCIDX").desColumn("DESCIDX").build(),
                ColumnDTO.builder().originColumn("LANG").desColumn("LANG").build(),
                ColumnDTO.builder().originColumn("DESCRIPTION").desColumn("DESCRIPTION").build());
        String tableName = TableEnum.PART_DESCS_V.getName();
        String dataBaseName = TableEnum.PART_DESCS_V.getDataBaseName();return TableDTO.builder().dataBaseName(dataBaseName).querySql("SELECT * FROM part_descs_v where LANG='Z'\n" +
                "UNION ALL SELECT * FROM part_descs_v where LANG='E'  and DESCIDX not in (SELECT DISTINCT DESCIDX FROM part_descs_v where LANG='Z')")
                .desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO part_nouns_v() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("NOUNIDX").desColumn("NOUNIDX").build(),
                ColumnDTO.builder().originColumn("LANG").desColumn("LANG").build(),
                ColumnDTO.builder().originColumn("NOUN").desColumn("NOUN").build());
        String tableName = TableEnum.PART_NOUNS_V.getName();
        String dataBaseName = TableEnum.PART_NOUNS_V.getDataBaseName();return TableDTO.builder().dataBaseName(dataBaseName).querySql("SELECT * FROM part_nouns_v where LANG='Z'\n" +
                "UNION ALL SELECT * FROM part_nouns_v where LANG='E'  and NOUNIDX not in (SELECT DISTINCT NOUNIDX FROM part_nouns_v where LANG='Z')")
                .desTable(tableName + NEWDATA).columns(columns).build();
    }

    protected static TableDTO sa_codes2_v() {
        List<ColumnDTO> columns = Lists.newArrayList(ColumnDTO.builder().originColumn("LANG").desColumn("LANG").build(),
                ColumnDTO.builder().originColumn("CLASS").desColumn("CLASS").build(),
                ColumnDTO.builder().originColumn("SACODE").desColumn("SACODE").build(),
                ColumnDTO.builder().originColumn("TYPE").desColumn("TYPE").build(),
                ColumnDTO.builder().originColumn("A_DATE").desColumn("A_DATE").build(),
                ColumnDTO.builder().originColumn("A_DESC").desColumn("A_DESC").build());
        String tableName = TableEnum.SA_CODES2_V.getName();
        String dataBaseName = TableEnum.SA_CODES2_V.getDataBaseName();return TableDTO.builder().dataBaseName(dataBaseName).querySql("SELECT * FROM sa_codes2_v where LANG='Z'").desTable(tableName + NEWDATA).columns(columns).build();
    }


}
